Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 10497 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.4 MiB |
| Average record size in memory | 144.0 B |
Variable types
| Numeric | 10 |
|---|---|
| Boolean | 3 |
| Categorical | 5 |
df_index is highly correlated with UserID and 1 other fields | High correlation |
UserID is highly correlated with df_index and 1 other fields | High correlation |
Yearly_avg_view_on_travel_page is highly correlated with Daily_Avg_mins_spend_on_traveling_page | High correlation |
total_likes_on_outofstation_checkin_received is highly correlated with Daily_Avg_mins_spend_on_traveling_page | High correlation |
montly_avg_comment_on_company_page is highly correlated with df_index and 1 other fields | High correlation |
Daily_Avg_mins_spend_on_traveling_page is highly correlated with Yearly_avg_view_on_travel_page and 1 other fields | High correlation |
df_index is highly correlated with UserID | High correlation |
UserID is highly correlated with df_index | High correlation |
Yearly_avg_view_on_travel_page is highly correlated with total_likes_on_outofstation_checkin_received and 1 other fields | High correlation |
total_likes_on_outofstation_checkin_received is highly correlated with Yearly_avg_view_on_travel_page and 1 other fields | High correlation |
Daily_Avg_mins_spend_on_traveling_page is highly correlated with Yearly_avg_view_on_travel_page and 1 other fields | High correlation |
df_index is highly correlated with UserID | High correlation |
UserID is highly correlated with df_index | High correlation |
df_index is highly correlated with UserID and 2 other fields | High correlation |
UserID is highly correlated with df_index and 2 other fields | High correlation |
yearly_avg_Outstation_checkins is highly correlated with df_index and 2 other fields | High correlation |
preferred_location_type is highly correlated with df_index and 2 other fields | High correlation |
total_likes_on_outofstation_checkin_received is highly correlated with Daily_Avg_mins_spend_on_traveling_page | High correlation |
Daily_Avg_mins_spend_on_traveling_page is highly correlated with total_likes_on_outofstation_checkin_received | High correlation |
df_index has unique values | Unique |
UserID has unique values | Unique |
week_since_last_outstation_checkin has 917 (8.7%) zeros | Zeros |
Reproduction
| Analysis started | 2022-04-30 06:06:31.344711 |
|---|---|
| Analysis finished | 2022-04-30 06:06:53.913180 |
| Duration | 22.57 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 10497 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6265.048204 |
| Minimum | 0 |
|---|---|
| Maximum | 11759 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 82.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 706.8 |
| Q1 | 3435 |
| median | 6511 |
| Q3 | 9135 |
| 95-th percentile | 11234.2 |
| Maximum | 11759 |
| Range | 11759 |
| Interquartile range (IQR) | 5700 |
Descriptive statistics
| Standard deviation | 3345.51008 |
|---|---|
| Coefficient of variation (CV) | 0.533995904 |
| Kurtosis | -1.138928624 |
| Mean | 6265.048204 |
| Median Absolute Deviation (MAD) | 2822 |
| Skewness | -0.1579051057 |
| Sum | 65764211 |
| Variance | 11192437.69 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 757 | 1 | < 0.1% |
| 4855 | 1 | < 0.1% |
| 11000 | 1 | < 0.1% |
| 8953 | 1 | < 0.1% |
| 2812 | 1 | < 0.1% |
| 765 | 1 | < 0.1% |
| 6910 | 1 | < 0.1% |
| 4863 | 1 | < 0.1% |
| 11008 | 1 | < 0.1% |
| Other values (10487) | 10487 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 8 | 1 | |
| 10 | 1 | |
| 11 | 1 | |
| 12 | 1 |
| Value | Count | Frequency (%) |
| 11759 | 1 | |
| 11758 | 1 | |
| 11757 | 1 | |
| 11756 | 1 | |
| 11755 | 1 | |
| 11754 | 1 | |
| 11753 | 1 | |
| 11752 | 1 | |
| 11751 | 1 | |
| 11750 | 1 |
| Distinct | 10497 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1006266.048 |
| Minimum | 1000001 |
|---|---|
| Maximum | 1011760 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 82.1 KiB |
Quantile statistics
| Minimum | 1000001 |
|---|---|
| 5-th percentile | 1000707.8 |
| Q1 | 1003436 |
| median | 1006512 |
| Q3 | 1009136 |
| 95-th percentile | 1011235.2 |
| Maximum | 1011760 |
| Range | 11759 |
| Interquartile range (IQR) | 5700 |
Descriptive statistics
| Standard deviation | 3345.51008 |
|---|---|
| Coefficient of variation (CV) | 0.00332467749 |
| Kurtosis | -1.138928624 |
| Mean | 1006266.048 |
| Median Absolute Deviation (MAD) | 2822 |
| Skewness | -0.1579051057 |
| Sum | 1.056277471 × 1010 |
| Variance | 11192437.69 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1001473 | 1 | < 0.1% |
| 1004407 | 1 | < 0.1% |
| 1008505 | 1 | < 0.1% |
| 1002364 | 1 | < 0.1% |
| 1000317 | 1 | < 0.1% |
| 1006462 | 1 | < 0.1% |
| 1010560 | 1 | < 0.1% |
| 1008513 | 1 | < 0.1% |
| 1002372 | 1 | < 0.1% |
| 1000325 | 1 | < 0.1% |
| Other values (10487) | 10487 |
| Value | Count | Frequency (%) |
| 1000001 | 1 | |
| 1000002 | 1 | |
| 1000003 | 1 | |
| 1000004 | 1 | |
| 1000005 | 1 | |
| 1000006 | 1 | |
| 1000009 | 1 | |
| 1000011 | 1 | |
| 1000012 | 1 | |
| 1000013 | 1 |
| Value | Count | Frequency (%) |
| 1011760 | 1 | |
| 1011759 | 1 | |
| 1011758 | 1 | |
| 1011757 | 1 | |
| 1011756 | 1 | |
| 1011755 | 1 | |
| 1011754 | 1 | |
| 1011753 | 1 | |
| 1011752 | 1 | |
| 1011751 | 1 |
Buy_ticket
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.4 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 8795 | |
| True | 1702 | 16.2% |
| Distinct | 331 |
|---|---|
| Distinct (%) | 3.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 281.2457845 |
| Minimum | 35 |
|---|---|
| Maximum | 464 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 82.1 KiB |
Quantile statistics
| Minimum | 35 |
|---|---|
| 5-th percentile | 182 |
| Q1 | 232 |
| median | 271 |
| Q3 | 325 |
| 95-th percentile | 410 |
| Maximum | 464 |
| Range | 429 |
| Interquartile range (IQR) | 93 |
Descriptive statistics
| Standard deviation | 68.28073068 |
|---|---|
| Coefficient of variation (CV) | 0.2427795702 |
| Kurtosis | -0.3072463864 |
| Mean | 281.2457845 |
| Median Absolute Deviation (MAD) | 45 |
| Skewness | 0.4081016958 |
| Sum | 2952237 |
| Variance | 4662.258182 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 255 | 169 | 1.6% |
| 262 | 163 | 1.6% |
| 270 | 160 | 1.5% |
| 217 | 137 | 1.3% |
| 232 | 137 | 1.3% |
| 247 | 123 | 1.2% |
| 240 | 120 | 1.1% |
| 225 | 118 | 1.1% |
| 285 | 117 | 1.1% |
| 264 | 116 | 1.1% |
| Other values (321) | 9137 |
| Value | Count | Frequency (%) |
| 35 | 4 | |
| 42 | 4 | |
| 135 | 3 | < 0.1% |
| 136 | 8 | |
| 137 | 6 | |
| 138 | 3 | < 0.1% |
| 140 | 2 | < 0.1% |
| 141 | 3 | < 0.1% |
| 142 | 4 | |
| 143 | 7 |
| Value | Count | Frequency (%) |
| 464 | 1 | < 0.1% |
| 463 | 1 | < 0.1% |
| 462 | 2 | < 0.1% |
| 461 | 2 | < 0.1% |
| 460 | 3 | |
| 459 | 2 | < 0.1% |
| 458 | 1 | < 0.1% |
| 457 | 3 | |
| 456 | 5 | |
| 455 | 7 |
preferred_device
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 82.1 KiB |
| Mobile | |
|---|---|
| Laptop |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mobile |
|---|---|
| 2nd row | Mobile |
| 3rd row | Mobile |
| 4th row | Mobile |
| 5th row | Mobile |
Common Values
| Value | Count | Frequency (%) |
| Mobile | 9389 | |
| Laptop | 1108 | 10.6% |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| mobile | 9389 | |
| laptop | 1108 | 10.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
total_likes_on_outstation_checkin_given
Real number (ℝ≥0)
| Distinct | 7566 |
|---|---|
| Distinct (%) | 72.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28169.87673 |
| Minimum | 3570 |
|---|---|
| Maximum | 152465 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 82.1 KiB |
Quantile statistics
| Minimum | 3570 |
|---|---|
| 5-th percentile | 5748 |
| Q1 | 16321 |
| median | 28178 |
| Q3 | 40529 |
| 95-th percentile | 49881.2 |
| Maximum | 152465 |
| Range | 148895 |
| Interquartile range (IQR) | 24208 |
Descriptive statistics
| Standard deviation | 14207.22205 |
|---|---|
| Coefficient of variation (CV) | 0.504340938 |
| Kurtosis | -0.1348271478 |
| Mean | 28169.87673 |
| Median Absolute Deviation (MAD) | 12007 |
| Skewness | 0.1112174145 |
| Sum | 295699196 |
| Variance | 201845158.4 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 11515 | 11 | 0.1% |
| 18550 | 9 | 0.1% |
| 24185 | 9 | 0.1% |
| 37870 | 9 | 0.1% |
| 44905 | 8 | 0.1% |
| 40110 | 8 | 0.1% |
| 34195 | 7 | 0.1% |
| 7070 | 7 | 0.1% |
| 12250 | 7 | 0.1% |
| 16275 | 7 | 0.1% |
| Other values (7556) | 10415 |
| Value | Count | Frequency (%) |
| 3570 | 2 | |
| 3577 | 1 | |
| 3578 | 1 | |
| 3605 | 2 | |
| 3611 | 1 | |
| 3614 | 1 | |
| 3618 | 1 | |
| 3620 | 1 | |
| 3621 | 1 | |
| 3631 | 1 |
| Value | Count | Frequency (%) |
| 152465 | 1 | |
| 152430 | 1 | |
| 52512 | 1 | |
| 52509 | 1 | |
| 52498 | 1 | |
| 52495 | 1 | |
| 52487 | 1 | |
| 52479 | 1 | |
| 52474 | 1 | |
| 52469 | 1 |
| Distinct | 30 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 82.1 KiB |
| 1 | |
|---|---|
| 2 | |
| 10 | |
| 9 | 340 |
| 3 | 336 |
| Other values (25) |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.359436029 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 3794 | |
| 2 | 844 | 8.0% |
| 10 | 617 | 5.9% |
| 9 | 340 | 3.2% |
| 3 | 336 | 3.2% |
| 7 | 336 | 3.2% |
| 8 | 320 | 3.0% |
| 5 | 261 | 2.5% |
| 4 | 256 | 2.4% |
| 6 | 236 | 2.2% |
| Other values (20) | 3157 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 1 | 3794 | |
| 2 | 844 | 8.0% |
| 10 | 617 | 5.9% |
| 9 | 340 | 3.2% |
| 3 | 336 | 3.2% |
| 7 | 336 | 3.2% |
| 8 | 320 | 3.0% |
| 5 | 261 | 2.5% |
| 4 | 256 | 2.4% |
| 6 | 236 | 2.2% |
| Other values (20) | 3157 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
member_in_family
Real number (ℝ≥0)
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.924930933 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 82.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 4 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.042121903 |
|---|---|
| Coefficient of variation (CV) | 0.3562894056 |
| Kurtosis | 1.278071422 |
| Mean | 2.924930933 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.003406428921 |
| Sum | 30703 |
| Variance | 1.086018062 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 3 | 4109 | |
| 4 | 2859 | |
| 2 | 1989 | |
| 1 | 1197 | 11.4% |
| 5 | 333 | 3.2% |
| 10 | 10 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1197 | 11.4% |
| 2 | 1989 | |
| 3 | 4109 | |
| 4 | 2859 | |
| 5 | 333 | 3.2% |
| 10 | 10 | 0.1% |
| Value | Count | Frequency (%) |
| 10 | 10 | 0.1% |
| 5 | 333 | 3.2% |
| 4 | 2859 | |
| 3 | 4109 | |
| 2 | 1989 | |
| 1 | 1197 | 11.4% |
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 82.1 KiB |
| Beach | |
|---|---|
| Financial | |
| Historical site | |
| Medical | |
| Other | |
| Other values (2) |
Length
| Max length | 15 |
|---|---|
| Median length | 8 |
| Mean length | 8.649233114 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Financial |
|---|---|
| 2nd row | Financial |
| 3rd row | Other |
| 4th row | Financial |
| 5th row | Medical |
Common Values
| Value | Count | Frequency (%) |
| Beach | 2424 | |
| Financial | 1894 | |
| Historical site | 1856 | |
| Medical | 1463 | |
| Other | 1307 | |
| Entertainment | 917 | 8.7% |
| Trekking | 636 | 6.1% |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| beach | 2424 | |
| financial | 1894 | |
| historical | 1856 | |
| site | 1856 | |
| medical | 1463 | |
| other | 1307 | |
| entertainment | 917 | 7.4% |
| trekking | 636 | 5.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Yearly_avg_comment_on_travel_page
Real number (ℝ≥0)
| Distinct | 99 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 75.12651234 |
| Minimum | 3 |
|---|---|
| Maximum | 685 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 82.1 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 41 |
| Q1 | 57 |
| median | 75 |
| Q3 | 93 |
| 95-th percentile | 109 |
| Maximum | 685 |
| Range | 682 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 23.19647818 |
|---|---|
| Coefficient of variation (CV) | 0.3087655404 |
| Kurtosis | 72.38135158 |
| Mean | 75.12651234 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | 2.872399338 |
| Sum | 788603 |
| Variance | 538.0765998 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 96 | 175 | 1.7% |
| 90 | 173 | 1.6% |
| 66 | 171 | 1.6% |
| 56 | 169 | 1.6% |
| 72 | 167 | 1.6% |
| 80 | 166 | 1.6% |
| 60 | 163 | 1.6% |
| 91 | 161 | 1.5% |
| 87 | 160 | 1.5% |
| 95 | 159 | 1.5% |
| Other values (89) | 8833 |
| Value | Count | Frequency (%) |
| 3 | 29 | |
| 31 | 24 | 0.2% |
| 32 | 43 | |
| 33 | 34 | |
| 34 | 35 | |
| 35 | 39 | |
| 36 | 49 | |
| 37 | 44 | |
| 38 | 60 | |
| 39 | 57 |
| Value | Count | Frequency (%) |
| 685 | 1 | < 0.1% |
| 615 | 1 | < 0.1% |
| 215 | 1 | < 0.1% |
| 125 | 7 | 0.1% |
| 124 | 3 | < 0.1% |
| 123 | 8 | 0.1% |
| 122 | 10 | |
| 121 | 11 | |
| 120 | 10 | |
| 119 | 24 |
total_likes_on_outofstation_checkin_received
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 5980 |
|---|---|
| Distinct (%) | 57.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6537.784034 |
| Minimum | 1009 |
|---|---|
| Maximum | 20065 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 82.1 KiB |
Quantile statistics
| Minimum | 1009 |
|---|---|
| 5-th percentile | 2136 |
| Q1 | 2947 |
| median | 4948 |
| Q3 | 8398 |
| 95-th percentile | 17871.4 |
| Maximum | 20065 |
| Range | 19056 |
| Interquartile range (IQR) | 5451 |
Descriptive statistics
| Standard deviation | 4708.251662 |
|---|---|
| Coefficient of variation (CV) | 0.7201601702 |
| Kurtosis | 1.005578467 |
| Mean | 6537.784034 |
| Median Absolute Deviation (MAD) | 2192 |
| Skewness | 1.37044156 |
| Sum | 68627119 |
| Variance | 22167633.72 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2377 | 11 | 0.1% |
| 2437 | 9 | 0.1% |
| 2404 | 9 | 0.1% |
| 2342 | 9 | 0.1% |
| 2380 | 8 | 0.1% |
| 2451 | 8 | 0.1% |
| 2570 | 8 | 0.1% |
| 2096 | 8 | 0.1% |
| 2793 | 8 | 0.1% |
| 2387 | 8 | 0.1% |
| Other values (5970) | 10411 |
| Value | Count | Frequency (%) |
| 1009 | 2 | |
| 1014 | 1 | |
| 1017 | 1 | |
| 1050 | 1 | |
| 1051 | 1 | |
| 1052 | 2 | |
| 1055 | 1 | |
| 1058 | 1 | |
| 1060 | 1 | |
| 1061 | 2 |
| Value | Count | Frequency (%) |
| 20065 | 1 | |
| 20056 | 1 | |
| 20038 | 1 | |
| 20036 | 1 | |
| 20032 | 1 | |
| 20030 | 1 | |
| 20008 | 1 | |
| 20004 | 1 | |
| 20000 | 1 | |
| 19999 | 1 |
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.20777365 |
| Minimum | 0 |
|---|---|
| Maximum | 11 |
| Zeros | 917 |
| Zeros (%) | 8.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 82.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 9 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.614122455 |
|---|---|
| Coefficient of variation (CV) | 0.8149335772 |
| Kurtosis | -0.04154014365 |
| Mean | 3.20777365 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.91199506 |
| Sum | 33672 |
| Variance | 6.833636211 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=12)
| Value | Count | Frequency (%) |
| 1 | 2733 | |
| 3 | 1605 | |
| 2 | 1503 | |
| 4 | 993 | 9.5% |
| 0 | 917 | 8.7% |
| 5 | 643 | 6.1% |
| 6 | 585 | 5.6% |
| 7 | 545 | 5.2% |
| 9 | 410 | 3.9% |
| 8 | 384 | 3.7% |
| Other values (2) | 179 | 1.7% |
| Value | Count | Frequency (%) |
| 0 | 917 | 8.7% |
| 1 | 2733 | |
| 2 | 1503 | |
| 3 | 1605 | |
| 4 | 993 | 9.5% |
| 5 | 643 | 6.1% |
| 6 | 585 | 5.6% |
| 7 | 545 | 5.2% |
| 8 | 384 | 3.7% |
| 9 | 410 | 3.9% |
| Value | Count | Frequency (%) |
| 11 | 54 | 0.5% |
| 10 | 125 | 1.2% |
| 9 | 410 | 3.9% |
| 8 | 384 | 3.7% |
| 7 | 545 | 5.2% |
| 6 | 585 | 5.6% |
| 5 | 643 | |
| 4 | 993 | |
| 3 | 1605 | |
| 2 | 1503 |
following_company_page
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.4 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 7549 | |
| True | 2948 | 28.1% |
| Distinct | 149 |
|---|---|
| Distinct (%) | 1.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 28.86986758 |
| Minimum | 11 |
|---|---|
| Maximum | 499 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 82.1 KiB |
Quantile statistics
| Minimum | 11 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 18 |
| median | 23 |
| Q3 | 28 |
| 95-th percentile | 37 |
| Maximum | 499 |
| Range | 488 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 47.53377955 |
|---|---|
| Coefficient of variation (CV) | 1.646484156 |
| Kurtosis | 62.97381813 |
| Mean | 28.86986758 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 7.883086906 |
| Sum | 303047 |
| Variance | 2259.460198 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 23 | 620 | 5.9% |
| 22 | 574 | 5.5% |
| 24 | 552 | 5.3% |
| 25 | 548 | 5.2% |
| 20 | 527 | 5.0% |
| 21 | 520 | 5.0% |
| 19 | 500 | 4.8% |
| 18 | 494 | 4.7% |
| 26 | 476 | 4.5% |
| 17 | 439 | 4.2% |
| Other values (139) | 5247 |
| Value | Count | Frequency (%) |
| 11 | 321 | |
| 12 | 325 | |
| 13 | 312 | |
| 14 | 379 | |
| 15 | 301 | |
| 16 | 346 | |
| 17 | 439 | |
| 18 | 494 | |
| 19 | 500 | |
| 20 | 527 |
| Value | Count | Frequency (%) |
| 499 | 1 | |
| 497 | 1 | |
| 491 | 1 | |
| 490 | 2 | |
| 488 | 1 | |
| 487 | 1 | |
| 486 | 1 | |
| 484 | 2 | |
| 483 | 2 | |
| 478 | 2 |
working_flag
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 10.4 KiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 8884 | |
| True | 1613 | 15.4% |
travelling_network_rating
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 82.1 KiB |
| 3 | |
|---|---|
| 4 | |
| 2 | |
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 4 |
| 3rd row | 2 |
| 4th row | 3 |
| 5th row | 4 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 3309 | |
| 4 | 3073 | |
| 2 | 2157 | |
| 1 | 1958 |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| 3 | 3309 | |
| 4 | 3073 | |
| 2 | 2157 | |
| 1 | 1958 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
number_of_adults
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 82.1 KiB |
| 0 | |
|---|---|
| 1 | |
| 2 | |
| 3 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 4497 | |
| 1 | 4266 | |
| 2 | 1115 | 10.6% |
| 3 | 619 | 5.9% |
Length
Histogram of lengths of the category
Pie chart
| Value | Count | Frequency (%) |
| 0 | 4497 | |
| 1 | 4266 | |
| 2 | 1115 | 10.6% |
| 3 | 619 | 5.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Daily_Avg_mins_spend_on_traveling_page
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 51 |
|---|---|
| Distinct (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.84471754 |
| Minimum | 0 |
|---|---|
| Maximum | 235 |
| Zeros | 36 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 82.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 8 |
| median | 12 |
| Q3 | 18 |
| 95-th percentile | 31 |
| Maximum | 235 |
| Range | 235 |
| Interquartile range (IQR) | 10 |
Descriptive statistics
| Standard deviation | 8.822850529 |
|---|---|
| Coefficient of variation (CV) | 0.6372719779 |
| Kurtosis | 50.24238823 |
| Mean | 13.84471754 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 3.040138233 |
| Sum | 145328 |
| Variance | 77.84269146 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10 | 995 | 9.5% |
| 9 | 599 | 5.7% |
| 8 | 585 | 5.6% |
| 6 | 558 | 5.3% |
| 7 | 488 | 4.6% |
| 11 | 475 | 4.5% |
| 13 | 474 | 4.5% |
| 14 | 448 | 4.3% |
| 12 | 441 | 4.2% |
| 15 | 427 | 4.1% |
| Other values (41) | 5007 |
| Value | Count | Frequency (%) |
| 0 | 36 | 0.3% |
| 1 | 296 | |
| 2 | 130 | 1.2% |
| 3 | 195 | 1.9% |
| 4 | 304 | |
| 5 | 390 | |
| 6 | 558 | |
| 7 | 488 | |
| 8 | 585 | |
| 9 | 599 |
| Value | Count | Frequency (%) |
| 235 | 1 | < 0.1% |
| 170 | 1 | < 0.1% |
| 135 | 1 | < 0.1% |
| 47 | 1 | < 0.1% |
| 46 | 3 | < 0.1% |
| 45 | 4 | < 0.1% |
| 44 | 7 | 0.1% |
| 43 | 4 | < 0.1% |
| 42 | 5 | < 0.1% |
| 41 | 19 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| df_index | UserID | Buy_ticket | Yearly_avg_view_on_travel_page | preferred_device | total_likes_on_outstation_checkin_given | yearly_avg_Outstation_checkins | member_in_family | preferred_location_type | Yearly_avg_comment_on_travel_page | total_likes_on_outofstation_checkin_received | week_since_last_outstation_checkin | following_company_page | montly_avg_comment_on_company_page | working_flag | travelling_network_rating | number_of_adults | Daily_Avg_mins_spend_on_traveling_page | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 1000001 | Yes | 307.0 | Mobile | 38570.0 | 1 | 2 | Financial | 94.0 | 5993 | 8 | Yes | 11 | No | 1 | 0 | 8 |
| 1 | 1 | 1000002 | No | 367.0 | Mobile | 9765.0 | 1 | 1 | Financial | 61.0 | 5130 | 1 | No | 23 | Yes | 4 | 1 | 10 |
| 2 | 2 | 1000003 | Yes | 277.0 | Mobile | 48055.0 | 1 | 2 | Other | 92.0 | 2090 | 6 | Yes | 15 | No | 2 | 0 | 7 |
| 3 | 3 | 1000004 | No | 247.0 | Mobile | 48720.0 | 1 | 4 | Financial | 56.0 | 2909 | 1 | Yes | 11 | No | 3 | 0 | 8 |
| 4 | 4 | 1000005 | No | 202.0 | Mobile | 20685.0 | 1 | 1 | Medical | 40.0 | 3468 | 9 | No | 12 | No | 4 | 1 | 6 |
| 5 | 5 | 1000006 | No | 240.0 | Mobile | 35175.0 | 1 | 2 | Financial | 79.0 | 3068 | 0 | No | 13 | No | 3 | 0 | 8 |
| 6 | 8 | 1000009 | No | 285.0 | Mobile | 7560.0 | 23 | 3 | Financial | 44.0 | 9526 | 0 | No | 21 | Yes | 2 | 0 | 10 |
| 7 | 10 | 1000011 | No | 262.0 | Mobile | 28315.0 | 16 | 3 | Medical | 84.0 | 2426 | 0 | No | 13 | No | 3 | 1 | 6 |
| 8 | 11 | 1000012 | No | 217.0 | Mobile | 5355.0 | 15 | 2 | Financial | 49.0 | 4193 | 0 | Yes | 12 | No | 4 | 0 | 10 |
| 9 | 12 | 1000013 | No | 232.0 | Mobile | 23450.0 | 26 | 1 | Financial | 31.0 | 2911 | 1 | No | 17 | No | 4 | 1 | 5 |
Last rows
| df_index | UserID | Buy_ticket | Yearly_avg_view_on_travel_page | preferred_device | total_likes_on_outstation_checkin_given | yearly_avg_Outstation_checkins | member_in_family | preferred_location_type | Yearly_avg_comment_on_travel_page | total_likes_on_outofstation_checkin_received | week_since_last_outstation_checkin | following_company_page | montly_avg_comment_on_company_page | working_flag | travelling_network_rating | number_of_adults | Daily_Avg_mins_spend_on_traveling_page | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10487 | 11750 | 1011751 | No | 231.0 | Mobile | 16423.0 | 28 | 4 | Historical site | 96.0 | 3845 | 1 | No | 26 | No | 2 | 0 | 12 |
| 10488 | 11751 | 1011752 | Yes | 383.0 | Mobile | 14399.0 | 28 | 3 | Other | 58.0 | 10910 | 6 | Yes | 28 | No | 2 | 1 | 23 |
| 10489 | 11752 | 1011753 | No | 302.0 | Mobile | 25317.0 | 24 | 1 | Other | 79.0 | 12093 | 0 | No | 24 | No | 1 | 1 | 29 |
| 10490 | 11753 | 1011754 | No | 247.0 | Mobile | 11418.0 | 5 | 3 | Historical site | 99.0 | 9983 | 1 | No | 28 | No | 2 | 0 | 16 |
| 10491 | 11754 | 1011755 | No | 210.0 | Mobile | 40886.0 | 5 | 3 | Other | 53.0 | 3024 | 2 | No | 32 | No | 4 | 0 | 14 |
| 10492 | 11755 | 1011756 | No | 279.0 | Laptop | 30987.0 | 23 | 2 | Historical site | 58.0 | 2616 | 4 | No | 36 | No | 3 | 1 | 23 |
| 10493 | 11756 | 1011757 | No | 305.0 | Mobile | 21510.0 | 6 | 1 | Historical site | 55.0 | 10041 | 4 | No | 30 | No | 1 | 1 | 11 |
| 10494 | 11757 | 1011758 | No | 214.0 | Mobile | 5478.0 | 4 | 3 | Beach | 103.0 | 6203 | 3 | Yes | 40 | Yes | 2 | 1 | 12 |
| 10495 | 11758 | 1011759 | No | 382.0 | Laptop | 35851.0 | 2 | 3 | Historical site | 83.0 | 5444 | 3 | No | 32 | No | 4 | 0 | 20 |
| 10496 | 11759 | 1011760 | No | 270.0 | Mobile | 22025.0 | 8 | 3 | Historical site | 104.0 | 4470 | 2 | No | 29 | No | 1 | 0 | 14 |